package com.orange.handler.impl;

import java.sql.SQLException;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.orange.handler.SchoolDataService;
import com.orange.modules.SchoolDataRepository;
import com.orange.modules.bean.school_data.AuthItemExportData;
import com.orange.modules.bean.school_data.AuthMoneyExport;
import com.orange.modules.bean.school_data.AuthResourceExport;
import com.orange.modules.bean.school_data.AuthSchoolRunningExport;
import com.orange.modules.bean.school_data.AuthStudentExport;
import com.orange.modules.bean.school_data.AuthTeacherExport;
import com.orange.modules.bean.school_data.AuthTeacherResouceExport;
import com.orange.modules.entity.school_data.AuthInspectionCollect;
import com.orange.modules.entity.school_data.AuthItemData;

@Service
public class SchoolDataServiceImpl implements SchoolDataService {

	@Autowired
	private SchoolDataRepository schoolDataRepository;
	
	@Override
	public List<AuthMoneyExport> queryAuthMoneyResouce(String major)
			throws SQLException {
		List<AuthMoneyExport> lists = this.schoolDataRepository.queryAuthMoneyResouce(major);
		return lists;
	}

	@Override
	public List<AuthResourceExport> queryAuthResouceData(String major)
			throws SQLException {
		List<AuthResourceExport> lists = this.schoolDataRepository.queryAuthResouceData(major);
		return lists;
	}

	@Override
	public List<AuthSchoolRunningExport> queryAuthSchoolRunning(String major)
			throws SQLException {
		List<AuthSchoolRunningExport> lists = this.schoolDataRepository.queryAuthSchoolRunning(major);
		return lists;
	}

	@Override
	public List<AuthStudentExport> queryAuthStudentData(String major)
			throws SQLException {
		List<AuthStudentExport> lists = this.schoolDataRepository.queryAuthStudentData(major);
		return lists;
	}

	@Override
	public List<AuthTeacherExport> queryAuthTeacherData(String major)
			throws SQLException {
		List<AuthTeacherExport> lists = this.schoolDataRepository.queryAuthTeacherData(major);
		return lists;
	}

	@Override
	public List<AuthTeacherResouceExport> queryAuthTeacherResource(String major)
			throws SQLException {
		List<AuthTeacherResouceExport> lists = this.schoolDataRepository.queryAuthTeacherResource(major);
		return lists;
	}

	@Override
	public List<AuthItemData> queryAuthItemExpertData(String major)
			throws SQLException {
		
		List<AuthItemData> lists = this.schoolDataRepository.queryAuthExportItemData(major);
		return lists;
	}

	@Override
	public List<AuthInspectionCollect> queryAuthInspectionCollect(String major)
			throws SQLException {
		List<AuthInspectionCollect> lists = this.schoolDataRepository.queryAuthInspectionCollect(major);
		return lists;
	}

	

	
	
}
